Viewing 15 posts - 46 through 60 (of 7,165 total)
A few things about this:
1.) This would be very difficult to achieve in T-SQL
2.) Why would you want to do this? There are much better tools already available (e.g. Mathematica)
3.)...
August 23, 2017 at 4:20 pm
August 23, 2017 at 6:40 am
Enabling Package logging is the simplest way to capture the information with no custom engineering involved to capture the data. Selectively turning on certain logging events for a Data Flow...
August 23, 2017 at 12:18 am
I want to get a message from a RemoteServer when a certain SQL job...
August 23, 2017 at 12:06 am
I agree with Jeff, are you splitting the file or is it arriving to you in this way? I see no need to split it.
A simple PowerShell script...
August 22, 2017 at 11:59 pm
August 22, 2017 at 11:42 pm
Converting incoming CSV files to XML in a generic field-name/field-value format will help solve the integration problem for you quite quickly by allowing you to then use one SSIS Package...
August 22, 2017 at 11:33 pm
Depends on what else is using the thing behind the UNC path, how reliable the connection to it is and how fast the server doing the restore happens to be....
August 22, 2017 at 11:15 pm
TheSQLGuru - Tuesday, August 22, 2017 9:43 PMOla.hallengren.com is my go-to solution for MX.
+1 for Ola's solution
August 22, 2017 at 11:10 pm
August 22, 2017 at 11:07 pm
karl 93387 - Friday, July 21, 2017 2:19 PMwhere isdate(col) = 0
careful using isdate when checking to see if...
August 22, 2017 at 10:59 pm
Viewing 15 posts - 46 through 60 (of 7,165 total)