5,946 reputation
11645
bio website billfellows.blogspot.com
location Kansas City, MO
age 40
visits member for 3 years, 9 months
seen 1 hour ago

Developer, devourer of pie, disciple of databases, dictator of datum, drinker of tea, delirious with alliterative devices

@billinkc

SQL Server MVP


4h
comment Treat database field as a flat file source
And no, you can't use a "Flat file source" because that's for items on the file system. Instead, since you need to access a database table-like object, you'll be looking at an OLE DB Source or an ADO.NET Source depending on your connection managers
4h
comment Treat database field as a flat file source
Is there a reason you can't just pop it off Service Broker directly?
23h
revised Applying Quotes Across Multiple Lines
Let's make an authoritative answer
2d
revised Transact-SQL, Ms SQL, My SQL
deleted 129 characters in body
2d
revised Monyog for SQL Sever
added 10 characters in body
Mar
24
comment OLE DB source not refreshing metadata when query is changed
Screen shots? Any chance you have an Expression on the Variable? That allows you to muck with the text there but the actual value will be overwritten with the expressed value
Mar
24
comment Help on the pivot query
Also, Northwinds is from SQL Server 2000. I salute you if you're trying to learn but there are more current releases and sample databases for you to play with
Mar
24
comment Help on the pivot query
@ms115 When you are asking someone for help, and they need more information to clarify a point or to understand your problem, telling them to go look in Northwind database moves this from a "Please help" situation to a "go do my work for me"
Mar
24
comment OLE DB source not refreshing metadata when query is changed
I think I'm missing the question. You have a Variable which contains a query. You edited the query to add a new column to said query. You have an OLE DB Source which uses your Variable as the source. When you click the component itself, you see the new column showing. And you are clicking over to the Columns tab, right? Not just previewing the data. Where is it not working?
Mar
21
answered SSDT on VS2013 for SQL Server 2012
Mar
19
awarded  Strunk & White
Mar
19
revised Problem with look up function
added 8 characters in body
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
Careful man, there's a beverage here
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
Using / reduces the likelyhood of someone failing to escape their paths in languages and scripts that use the backslash character for character escape sequences
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
@swasheck It is general advises between the two
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
Windows uses \ as a directory separator. Linux uses / as a directory separator
Mar
17
comment How can I invoke an SSIS package from SQL Agent, via T-SQL, using a proxy
FWIW, I happen to script out the create_execution procedures and yeah, I'm guessing somewhere with all the impersonation and reverts in there things go poorly. I suspect Agent has a different mechanism, similar to a RunAs that allows it to not get fouled up whereas the TSQL impersonation does. shrug
Mar
13
comment Run SSIS Package as different user
Doesn't this assume that they are using SQL Server Authentication when they specifically mentioned "run as a different windows account and not a SQL account."
Mar
13
answered Run SSIS Package as different user
Mar
13
awarded  Notable Question