Need basic.

Hi All,

Can this be done and if so can you give a bullet list of the steps need to accomplish this.

I need to load a bunch of files into a stagging table. Need to loop through the files and load them.

Thanks,

Michael

Essentially you're looking at is the following:

1) A for each container using the for each file enumerator.

2) Within that, you'll need to assign the filepath to a variable

3) Within the container, create a dataflow task with a flatfile source and a sql server destination, mapping the columns.

4) dynamically change the connection string of the flatfile source (properties/expression)

Hope this helps

|||

Thanks Rick,

That is a good start, I will see how far I can get.

Michael

Need a guru

To all guru's:
I have something that sounds simple in theroy, but I haven't quite figured
out what I need to do to accomplish this. Simply put here is what I'd like t
o
do.
1. User logs into database/application
2. Upon login, update a table that contains the users login name (not
sysxlogins or sysusers) with the time of the login.
I've tried several update scripts, but none of them work. I think I'm at a
wall and hoping someone could provide a sample of what I could do to
accomplish this.If it's via an application, you could easily trigger a customised stored
procedure that logs username/date into a table.
i.e create sp to insert data , exec sp when logging in
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Big Ern" <BigErn@.discussions.microsoft.com> wrote in message
news:7F42AC1C-775B-4900-91B7-47CD4A3F13F0@.microsoft.com...
> To all guru's:
> I have something that sounds simple in theroy, but I haven't quite figured
> out what I need to do to accomplish this. Simply put here is what I'd like
to
> do.
> 1. User logs into database/application
> 2. Upon login, update a table that contains the users login name (not
> sysxlogins or sysusers) with the time of the login.
> I've tried several update scripts, but none of them work. I think I'm at a
> wall and hoping someone could provide a sample of what I could do to
> accomplish this.