Forum Replies Created
Viewing 15 posts - 31 through 45 (of 162 total)
-
RE: SSIS: trouble parameterising SQL
if you click the elipses button at the right of the expression property field for the variable, the expression builder will open up and you can use that to build...
Life: it twists and turns like a twisty turny thing
-
RE: SSIS to FlatFile
unfortunately, i don't have any experience in creating unix files so this might be where i sign off.
i do know that you can switch column headers on or...
Life: it twists and turns like a twisty turny thing
-
RE: SSIS to FlatFile
so that would imply that the query is working fine, but there is some problem writing to the file.
could you change the query and replace the single column with all...
Life: it twists and turns like a twisty turny thing
-
RE: SSIS to FlatFile
when you say you preview the query, is that in SSMS or using a data viewer in the data flow? (apologies if these questions seem basic or pointless, but sometimes...
Life: it twists and turns like a twisty turny thing
-
RE: SSIS to FlatFile
is the problem that the file you create is empty? have you check the data coming from the source using a data viewer?
Life: it twists and turns like a twisty turny thing
-
RE: SSIS to FlatFile
are you hoping to make a comma separated file?
Life: it twists and turns like a twisty turny thing
-
RE: SSIS to FlatFile
it's difficult to know without being able to see the sql itself.
tom
Life: it twists and turns like a twisty turny thing
-
RE: SSIS to FlatFile
can you give an example of the query you are running?
tom
Life: it twists and turns like a twisty turny thing
-
RE: getting reports in an excel sheet on a data pattern
the For loop will manage the conditions needed to control the loop. In the For Loop section of the editor you have three properties: InitExpression, EvalExpression, AssignExpression.
InitExpression: this will...
Life: it twists and turns like a twisty turny thing
-
RE: Task to trigger a flag..
if it were me, i would probably copy the row identifiers of the data being extracted into a separate, temporary data destination in the data flow, along side your main...
Life: it twists and turns like a twisty turny thing
-
RE: getting reports in an excel sheet on a data pattern
you could use a for loop to do all the hard work for you on this one.
you set the for loop to use a date as the limit, so you...
Life: it twists and turns like a twisty turny thing
-
RE: Login Failed for user "sa"
is this one of your original packages or did you inherit it? the reason i ask is that if you inherited it, perhaps the original coder made the db...
Life: it twists and turns like a twisty turny thing
-
RE: Data Check and Notification within SSIS
Do you need to know just of the existence of null entries in rows, or do you need to see the specific rows themselves?
If the first, you could use an...
Life: it twists and turns like a twisty turny thing
-
RE: Tricky If-Then-else logic
Is your constraint from SEQ_Stage1 to SEQ_Stage2 set as an OR or AND constraint?
If this was me, I would probably put the script task and the the SEQ_Stage1 and SEQ_Stage2...
Life: it twists and turns like a twisty turny thing
-
RE: Error when scheduling SSIS package
couldn't make sense of the error message. however, just a quick check: is the account that runs the package a proxy account?
tom
Life: it twists and turns like a twisty turny thing
Viewing 15 posts - 31 through 45 (of 162 total)