Viewing 15 posts - 9,406 through 9,420 (of 13,874 total)
martin.hock (2/6/2014)
27 at the moment, number increasing.
The most comfortable solution would be a table stored on a master server, from where the batch file fetches all information, which packages...
February 6, 2014 at 12:21 am
I was already thinking about a batch job, that uploads the packages to multiple servers using DTUTIL.exe
But at the moment I have no clue how to.
Out of interest, how many...
February 5, 2014 at 11:57 pm
I tried the UNPIVOT transformation for this problem and after pratting about with it for a while in an attempt to make it work, I have come down soundly on...
February 5, 2014 at 11:51 pm
Evil Kraig F (2/5/2014)
Phil Parkin (2/5/2014)
February 5, 2014 at 10:50 am
+1 to Lempster's answers, I agree with them all. Though I would more strongly recommend using the project model in 2012 - been using it for about a year and...
February 5, 2014 at 8:17 am
Can you post the T-SQL of the query from your ExecuteSQL task please?
February 5, 2014 at 12:09 am
jameslauf (2/4/2014)
I have made a SQL Task and set the result to Single Row and put in my...
February 4, 2014 at 1:59 pm
jameslauf (2/3/2014)
I have a Flat File Source that has 30 columns and a Destination Table that has 31...
February 3, 2014 at 11:51 pm
Perhaps you could try this.
1) Send all of your potential updates to a staging table.
2) Do a Merge from the staging table to perform the update using a source something...
January 28, 2014 at 10:09 pm
DaveDB (1/24/2014)
"Perhaps the reason for my request for additional material is becoming clearer now.
The fact that accomplished professionals, who would usually be able to...
January 24, 2014 at 10:44 am
Narly254 (1/23/2014)
Thank you It took some time but that helped a lot!
Well done. Quality coding takes time, but pays off in the long run 🙂
January 23, 2014 at 9:55 am
I have just downloaded SQLEnlight and started evaluating it and would be interested to hear any other comments about this product. My intention is to use it primarily for static...
January 23, 2014 at 8:41 am
Koen Verbeeck (1/23/2014)
You could add a row number (using a script component) to both flows and then use the MERGE JOIN component.
+1
January 23, 2014 at 3:45 am
I'm using a simple set up. Excel Source---Data Conversion (for the routing ID column) and an OLE DB Command
If anyone knows a work around or knows exactly how to fix...
January 22, 2014 at 12:39 pm
nonghead-webspam (1/17/2014)
January 20, 2014 at 1:04 am
Viewing 15 posts - 9,406 through 9,420 (of 13,874 total)