Viewing 15 posts - 9,406 through 9,420 (of 13,883 total)
And if it is possible with script component please send code ...
It is possible, but I'm not going to write the code for you - unless you want to hire...
February 10, 2014 at 12:29 am
How many files are we talking about and also how many different layouts?
Multiple data flows (one per file type) is one way of handling this.
Another is to send all of...
February 9, 2014 at 7:53 am
..load all this columns into single columns ...
Please explain what you mean by this.
In general, for every different file format, you will need a separate dataflow. Multiple files with...
February 7, 2014 at 3:15 am
Can you explain in more detail what do you mean by this bit please?
.. tried to copy as .xlsx ...
February 7, 2014 at 12:07 am
Scott Coleman (2/6/2014)
February 6, 2014 at 8:36 am
I like T-SQL as much as the next guy, but when someone is talking about transforming data in SSIS I don't assume T-SQL is the only answer.
You seem to be...
February 6, 2014 at 8:08 am
battula.ramu6 (2/6/2014)
February 6, 2014 at 3:38 am
chetan.deshpande001 (2/6/2014)
--Edit
I'm sorry for the formatting/colors ..as this is my first post and do not know how...
February 6, 2014 at 1:28 am
martin.hock (2/6/2014)
Never used it. But if you think it will solve my problem, I will 😉
Certainly a good opportunity for you to learn. I am no PoSh guru by any...
February 6, 2014 at 12:41 am
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
Viewing 15 posts - 9,406 through 9,420 (of 13,883 total)