FYI, all about SQL is new to me. I would appreciate it if someone could help
me on
the following :-
1) I have one text file containing 8 fields separated by pipes (|) and 1000
of rows
eg:-
Chang|Michael|acno1234566|03052005|154.26|1|0|655426.26
- Is it possible to import the above kind of text files by using the
query analyzer
(transact-SQL) without using DTS into the following table format.
nvarchar|nvarchar|nvarchar|dd/MM/yyyy|decimal|logical|logical|decimal
- If yes, please help/show me the samples and how can I execute it from
dos
prompt by using command line.
- If no, I have to use DTS. How to execute DTS against the above data
using
command line.
Help needed with DTS ... think I know how to do that piece of it, by putting the variables in a SQL... Provider for SQL onto the DTS screen, and a single text file there, and then ...set pkg = DTSGlobalVariables.Parent ... I know the copy command itself is not an issue, ... (microsoft.public.sqlserver.dts)
Re: No roeset returned ... I've seen this happen when multiple sql commands are used, ... You can run a DTS package from a Windows script using the dtsrun command.... You can set up a job that executes the DTS package and execute the job ... (microsoft.public.sqlserver.dts)
Re: No roeset returned ... I've seen this happen when multiple sql commands are used, ... You can run a DTS package from a Windows script using the dtsrun command.... You can set up a job that executes the DTS package and execute the job ... (microsoft.public.sqlserver.dts)
Re: TEXT Files ... > without using DTS into the following table format. ... You might wish to check out the descriptions of the BULK INSERT command... How to execute DTS against the above data ... (microsoft.public.sqlserver.mseq)
Re: Execute DTS 2000 Package in SQL 2005 fails ... Another way to execute DTS packages in SQL 2005, ...SSIS package "CopyFundWareTables.dtsx" starting. ... Error: 0x0 at Execute DTS 2000 Package Task: ... (microsoft.public.sqlserver.dts)
