Viewing 15 posts - 11,551 through 11,565 (of 13,870 total)
Other than the ideas put forward by myself and Todd, I know of no way forward for you.
There is nowhere in the system where you can set a flag: "Skip...
March 9, 2011 at 12:45 am
This is a bit out of my domain.
Was that deliberate?? Nice pun!
March 8, 2011 at 10:55 am
Not in the package, but within the job set-up.
March 8, 2011 at 7:31 am
I'm with Craig on that - can I ask what made you post this question in the SSIS forum? Do you have a certain solution or methodology in mind that...
March 7, 2011 at 12:17 pm
Try this:
@[System::PackageName] + RIGHT((DT_STR,4,1252)YEAR(GETDATE()),2) + RIGHT("0" + (DT_STR,2,1252)MONTH(GETDATE()),2) + RIGHT("0" + (DT_STR,2,1252)DAY(GETDATE()),2)
March 7, 2011 at 10:15 am
quillis131 (3/7/2011)
how should i cast package name variable and getdate.....can anyone give mee the exact expressions ...new to ssis
Please take a little more care with your question.
What do you mean...
March 7, 2011 at 9:33 am
jcrawf02 (3/4/2011)
Phil Parkin (3/4/2011)
Just dive in and keep asking questions and you'll soon gain the requisite experience.
heh...makes me think of that sig (can't remember whose at the moment) "semper in...
March 4, 2011 at 6:58 am
jcrawf02 (3/4/2011)
Jeff Moden (3/3/2011)
Heh... or just do it all in T-SQL stored procedures. :-D:-P;-)
How do I decide when to use subpackages vs stored procedures vs straight SQL tasks? I would...
March 4, 2011 at 6:42 am
Pah, you beat me to it!
March 4, 2011 at 5:25 am
CozyRoc (3/4/2011)
Koen Verbeeck (3/4/2011)
Then you can construct a dynamic SQL statement in...
March 4, 2011 at 5:24 am
You're looking in the wrong place.
Try the 'Project' menu - the item at the bottom of that menu will say [project name] properties - select that.
March 3, 2011 at 10:10 am
Koen Verbeeck (3/3/2011)
Phil Parkin (3/3/2011)
Sorry, remove single quotes and try again.
Dammit, if that is the solution, I've wasted 5 minutes of my life typing an answer while continuously checking the...
March 3, 2011 at 7:41 am
As long as the files have consistent formats (same order/number/data type of fields), it is possible.
SSIS is not good in scenarios where you want to be able to handle file...
March 2, 2011 at 1:56 pm
Viewing 15 posts - 11,551 through 11,565 (of 13,870 total)