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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-07-26 : 09:30:42
|
| Hi,I think I may have mis-guided some of you in my previous post.So I thought I explain it properly this time in a new post...Here is the description of the ssis package:Inside the connection manager there is a connection to the sql server database and a flat file connection.The flat file connection inside the connection manager has the expression seti.e. ConnectionString set to @[User::FileName]And so there is nothing inside the connectionstring property of this flatfile connection.Inside control flow:1)Dataflow which contains a flat file source and an ole db destinationThe flatfile source is supposed to pickup the .csv file that gets passed to the ssis package.Then the ole db destination is where the .csv gets imported into a sql server table.2)Back in the control flow, there is a task that calls a stored procedure with the parameter which is set to FileNameThe question is:How does this FileName parameter gets set before it is passed to the stored procedure?Many thanks |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-08-21 : 05:35:36
|
| Presumably, you are intending to pass in the variable that you used to store the connection string (@[User::FileName]), which will already be initialised by the time you come to call the stored proc (assuming that you've successfully imported some data). So, are you asking how this is set prior to your data flow?Mark |
 |
|
|
|
|
|
ssis - filename