Viewing 15 posts - 2,476 through 2,490 (of 11,678 total)
Mr. Kapsicum (6/25/2014)
Hi Koen,Thanks for the Reply.
But Can you please help me with some other Solution, I cannot use SSIS in this Case.
Can BCP help in this case.
Regards,
Well, your...
June 25, 2014 at 5:15 am
Take a look at the Export Column transformation in SSIS.
June 25, 2014 at 4:27 am
SSIS is not build to be interactive.
This means there are only work arounds, such as looping and using WAITFOR in TSQL or even messageboxes in the designer.
It seems splitting it...
June 25, 2014 at 2:54 am
The job steps are stored in the [msdb].[dbo].[sysjobsteps] table.
You can filter on the subsystem (only TSQL) and then search inside the command for email addresses.
June 25, 2014 at 12:59 am
peacesells (6/24/2014)
June 25, 2014 at 12:01 am
Can you give the table DDL if possible, some sample input and the desired output?
In the first link of my signature you find an article that helps you with those...
June 24, 2014 at 11:58 pm
ag1975 (6/24/2014)
Thanks for your advice.
I ended up recreating the entire data flow, and now the error has disappeared. I think I may have run into some strange corner case...
June 24, 2014 at 3:09 pm
Luis Cazares (6/24/2014)
On a completely different subject, I'm taking 20467BC course this week and found some surprises like using...
June 24, 2014 at 1:06 pm
Can you check the data types of all the columns in the data flow and compare them with the data types assigned in the input buffer? (you can find this...
June 24, 2014 at 1:03 pm
Grant Fritchey (6/24/2014)
Koen Verbeeck (6/24/2014)
Grant Fritchey (6/23/2014)
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
Nicely done.
Yes, I'm getting closer 😉
Well, not quite so close...
June 24, 2014 at 5:20 am
If you don't specify any package configurations in the package itself, it should normally run successfully.
You can leave the default protection level, but you will get some warnings about SSIS...
June 24, 2014 at 3:00 am
Grant Fritchey (6/23/2014)
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
Nicely done.
Yes, I'm getting closer 😉
June 24, 2014 at 12:07 am
Try debugging the old school way. Add messagebox at every line and see how far you get...
June 24, 2014 at 12:04 am
Viewing 15 posts - 2,476 through 2,490 (of 11,678 total)