5,543 reputation
11341
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 3 years, 6 months
seen yesterday

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

@billinkc

SQL Server MVP


1d
revised SSIS import with header record
Eliminated autogenerated comments
Dec
18
comment Microsoft recommends using Rowversion over timestamp , but i can not find “rowversion” data type inside my sql server 2008 R2
@johnG GIVE IT A TRY!
Dec
18
comment Microsoft recommends using Rowversion over timestamp , but i can not find “rowversion” data type inside my sql server 2008 R2
Did you look at the picture? i.stack.imgur.com/5aZ59.png
Dec
18
comment Microsoft recommends using Rowversion over timestamp , but i can not find “rowversion” data type inside my sql server 2008 R2
@johnG Data types are Samesies
Dec
18
revised How to retreive deleted records in a trigger on a table with composite primary key
MSSQL isn't a thing
Dec
18
comment How do I create a partition using a bit field in SQL Server 2014
What do your query plans look like before and after for a sampling of your expected workload?
Dec
17
comment SSIS Condition that include two connections/data bases
To restate, you need to populate a column based on whether a reference record was found? If exists, then 1, else 2
Dec
17
answered Backup Database Task - What's the number at the end of the filename?
Dec
16
revised SSIS - ODBC Parameter Size
deleted 21 characters in body
Dec
11
comment Granting permissions to SSIS for developer
BOL? Ain't nobody got time for that (I had to request the role yesterday or I'd have forgotten about it)
Dec
11
comment Granting permissions to SSIS for developer
For a project deployment scenario, SSISDB has a specific ssis_admin role that is probably more suitable than giving them owner
Dec
4
comment Loading XML data from SQL Server directly into MarkLogic?
Knowing nothing of MarkLogic, I find it's helpful to restate questions without an emphasis on a particular technology. Thus, "how can I load data directly into MarkLogic" If you have the answer to that, then it becomes easy to swap in data sourced from SQL Server and possibly using SSIS as the conduit for moving the data. That said, SSIS has no native connectors for MarkLogic.
Dec
4
answered Getting new and updated data with an archive column
Dec
2
comment Can't connect to SSIS being installed after SQL Server 2014
This question needs concrete details. You changed the xml file - how? You assigned permissions - which? They cannot connect - how? The error message they receive is ?
Dec
2
comment Getting new and updated data with an archive column
How about making use of the OUTPUT virtual table? Set your transaction isolation level correctly (snapshot/serializable) so that you only see the rows as of the moment your process begins. Use the following for your OLE DB Source UPDATE T SET Archive = 1 OUTPUT DELETED.* FROM Table T WHERE T.Archive = 0; That updates everything in a nice atomic operation with a side effect of generating the target output into your data flow buffers. Route that to your destination and it's done. Nice and neat
Dec
2
reviewed Approve Can't connect to SSIS being installed after SQL Server 2014
Dec
1
revised Replication Madness
added 346 characters in body
Dec
1
comment Replication Madness
@MaxVernon I guess that means the death of untold lives is less than EE licensing and/or increased disk capacity. Pity too, lives these days are just falling in price. In my day, a life would buy you a steak and kidney pie, a cup of coffee, a slice of cheesecake and a newsreel. With enough change left over to ride the trolley from Battery Park to the polo grounds.
Dec
1
comment SSIS cannot access the file
What I would propose is identifying what specifically is failing. It sounds like there a few different candidates for failure in play here: Network share - are you using a UNC path \\server\share or a mapped drive `S:` Since this is Excel, you are running the job in 32 bit mode, right? How does it access the Excel file - read or write? If you make a similar package that just attempts to access the directory (foreach file enumerator), does it "see" the files there (this can help identify permission issues)
Dec
1
comment SSIS cannot access the file
Perhaps it's my ignorance, but I don't see how changing your package protection level is going to benefit this. It doesn't appear to be an issue related to a connection manager which uses stored credentials