Viewing 15 posts - 9,571 through 9,585 (of 13,874 total)
Dwain does it again - nice article sir!
November 5, 2013 at 5:35 am
dwilliscp (11/1/2013)
November 4, 2013 at 4:46 am
Nice article. Your numbering system needs alignment (starts off zero-based and moves to one-based in the results table).
I would be interested to see whether the final 'staging table' option would...
October 31, 2013 at 8:52 am
Here's another version for lazy people:
Using Service broker (SQL Server) to call a WCF service which could add data to the queue. There are tables related to the service broker...
October 31, 2013 at 6:12 am
frdrckmitchell7 (10/29/2013)
I have a table (stock) that I need to update every day from a certain date (the first day of the month) to the...
October 30, 2013 at 1:18 am
Matt Miller (#4) (10/29/2013)
If the input file is to simply be...
October 30, 2013 at 1:13 am
anjanbv (10/30/2013)
Am able to get the script for getting package names but am not able to get database info, connection string and users details.
When you say users details, do you...
October 30, 2013 at 1:07 am
... and of course the file is now Alistair_McGowan''s_Big_ Impression_S4_Captions_Jan_2013_634940195179370992.doc'
I do not understand this bit. Let me explain why.
Step 1: create the SQL
----------------------
Dim fileSystemPath As String
fileSystemPath = Dts.Variables("User::SingleFileName").Value
Dts.Variables("User::destNameSQLQuery").Value = ""...
October 28, 2013 at 12:59 pm
pnr8uk (10/28/2013)
October 28, 2013 at 9:41 am
pnr8uk (10/28/2013)
The FileSystemPath has to match exactly, so if I remove the apostrophes...
October 28, 2013 at 6:41 am
How about replacing ' with '' in your fileSystemPath variable when you create the SQL?
October 28, 2013 at 4:50 am
blasto_max (10/28/2013)
October 28, 2013 at 1:50 am
Thanks for the concise article Dwain - an interesting read as usual.
October 27, 2013 at 11:31 pm
To assign the results of a query to an object variable, use an ExecuteSQL task, not a dataflow. Examples abound, here's one I found.
October 27, 2013 at 3:11 pm
Viewing 15 posts - 9,571 through 9,585 (of 13,874 total)