Viewing 15 posts - 8,836 through 8,850 (of 13,876 total)
An interesting introduction, thanks Sebastian. I shall look forward to the next items in the series.
Writing tests is clearly an initial overhead, which one expects to be worth the investment...
December 31, 2014 at 2:12 am
You could try using the Import Wizard, saving the package it produces and then comparing that with the one you've created manually.
But if I had to guess, it sounds like...
December 30, 2014 at 9:48 am
sandhya.msbi (12/29/2014)
I have 2 tables source & destination and I have to truncate destination and laod from source. these 2 stpes should happen in one transaction. but I should...
December 30, 2014 at 3:15 am
It would be helpful to know how the output is going to be used.
December 19, 2014 at 4:35 am
You want one resultset, but with different columns from different tables? Can't be done.
December 18, 2014 at 7:59 am
vipin_jha123 (12/18/2014)
Thanks Phil,I was in search of a way where I can schedule a BIML file to generate SSIS package.
Would it be possible ?
Possible? Perhaps, though I don't think many...
December 18, 2014 at 4:07 am
Michael Meierruth (12/18/2014)
SELECT Y + X AS Position
FROM (VALUES ('01'), ('02'), ('03'), ('04'), ('05'), ('06'), ('07'), ('08'), ('09'), ('10')) AS X(X)
join
...
December 18, 2014 at 3:11 am
vipin_jha123 (12/18/2014)
I have created simple BIML Script file which generating a SSIS Package.
It Contanis Single Data Flow Task ,OLEDB Source and OLEDB Destination.
Now my Concern is that my new...
December 18, 2014 at 3:08 am
Guitar_player (12/18/2014)
Thanks...
December 18, 2014 at 2:38 am
Guitar_player (12/18/2014)
I am using the Project Connection Managers and i have parameterize them (Made them as...
December 18, 2014 at 2:11 am
Sounds like you are doing it right.
Are you using connection strings rather than Project Connection Managers for a reason?
December 18, 2014 at 2:03 am
Guitar_player (12/17/2014)
I have tried the other method as Deployed my project in the SSIS catalog and then created a Environment variable...
December 18, 2014 at 12:50 am
marcia.j.wilson (12/17/2014)
December 18, 2014 at 12:31 am
Viewing 15 posts - 8,836 through 8,850 (of 13,876 total)