add text to a column

Hi,
I am mapping the .csv files to a destination table in sql server.
The names of each column in the .csv file is the same as the ones in the destination table.
In the destination table there is an extra field i.e. FileTypeField

Here is the question;
When transfering the data from .csv to the destination table i.e flat file source to oledb destination, I would like to place a text into the field FileTypeField
I do not see an option to do this. Can you help please?
Thanks

Use a derived column transformation to add a column to the data flow. Then you'll just map that new column to the destination table.|||Thanks

add 1000 users...

hi
how can I add 1000 users (user_name, password) from txt, csv file to
aspnetdb.mdf database?
thanks
ereszBCP the data into a table. Then construct an sp_adduser statement for each
row in the table and dynamically execute it. If it is 2005, you would use a
CREATE USER command instead of sp_adduser.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
<eresz@.op.pl> wrote in message
news:1145538712.170169.133870@.j33g2000cwa.googlegroups.com...
> hi
> how can I add 1000 users (user_name, password) from txt, csv file to
> aspnetdb.mdf database?
>
> thanks
> eresz
>|||> If it is 2005, you would use a CREATE USER command instead of sp_adduser.
And if eresz's intent is to add application users, the appropriate aspnetdb
procs are dbo.aspnet_Membership_CreateUser and perhaps
dbo.aspnet_UsersInRoles_AddUsersToRoles.
Hope this helps.
Dan Guzman
SQL Server MVP
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:OwiO$YPZGHA.3400@.TK2MSFTNGP02.phx.gbl...
> BCP the data into a table. Then construct an sp_adduser statement for
> each row in the table and dynamically execute it. If it is 2005, you
> would use a CREATE USER command instead of sp_adduser.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> <eresz@.op.pl> wrote in message
> news:1145538712.170169.133870@.j33g2000cwa.googlegroups.com...
>