sql variable problem
Im tryng to execute a bulk insert command with a variable text file. I declare
a variable for the file but is not working with the bulk insert. Also I
try to assing all the command to a variable so I just execute that variable
but to declare a variable you need to enclose statement with '', and I can
assing the row and field terminator because of this
Here is my command in sql:
Bulk insert Hdb.dbo.FTPdata From "@filename"
Fieldterminator = '|',
Rowterminator = '\n'
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center