Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PanzerAttack
Yak Posting Veteran
71 Posts |
 Posted - 2011-06-28 : 09:51:09
|
| Sorry but I've been at this for ages and am stuck.I have a table which has a column named [Import Date]Data Type = datetimeDefault Value or Binding = (getdate())When I run the SSIS though the field is filled with NULLWhen I look at the Package in the BI Development Studio, select Advanced Editor and then Input and Output Properties, I can see the Data Type.My question after all that is, how to I make Import Date populate everytime the SSIS Package is run? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-28 : 10:13:55
|
| Remove the column from the maping in ssis and it should use the defulat.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
PanzerAttack
Yak Posting Veteran
71 Posts |
Posted - 2011-06-28 : 10:46:48
|
| Thanks, only started using sql 2005 yesterday, so please let me clarify what I've done because it's still not working.In the BI Development Studio I deleted the Import Date column in External Columns. I then reimported using my SSIS Package.However, the field is NULL and when I check the External Columns, it's put itself back in. The field in the table is set to (getdate()) and datatype datetime |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-28 : 11:23:35
|
| In the dataflow there will be a mapping of the source to destination columns. You need to delete it from there.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
PanzerAttack
Yak Posting Veteran
71 Posts |
Posted - 2011-06-29 : 10:18:01
|
| Thanks for the help. My noddyness. I have the Derived field after the ODB Object, I swapped them and it works. |
|
|
|
|
|
|
SSIS Default GETDATE()