MS SQL 2005 SSIS package default values

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I've got an SSIS package that's been running for years just fine. It imports some data into a permanent temp table from text files. Now, I need to put data into some columns in the temp table that doesn't come from the text file. I CANNOT alter the text file as it comes from another system. But I need to put the import date/time and another value into the temp table at the time the SSIS package is run. When I run the import wizard to create the package, there doesn't seem to be the possibility of putting data into the table that doesnt come from the text file. I tried adding another column to the list but it insists on matching it up wiht something from the text file and won't allow me to continue. So I'm thinking the only way to do this is to edit the package in bus. intel. dev. studio. From there I could add the values I need. Am I on the right track? Or is there another way to do this?

Posted 24-Feb-12 3:55am

avianrand

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2012-02-24T04:01:00

Solution 1

Either create a new script task that appends the desired data to the database after the data is imported, or assuming the task that performs the import calls a stored proc, have the stored proc append the additional data.

Posted 24-Feb-12 4:01am

#realJSOP

Comments

avianrand 24-Feb-12 10:17am

That's what I 'm doing now, but where this is currently run by one person at a time, there will be 2 more offices that could do this all at the same time. The data that I'm putting in is a "date/time of import" for the entire batch (every row must have the same date/time so it can't be a datetiemstamp) and an office designation. These 2 columns are initially null and are updated immediately after the import. The update is filtered on the nulls. But it's remotely possible now that 2 people could run this at the exact same time and end up with one of them populating the null values on both batches. I tried to get the people that create the text file to add an office designator column but they can't do that apparently.