Col1 Col2 Col3 Col4 Col5 Col6

ted

This is what I got in the result.

I have 50000 rows in my original table

Thanks

If there are multiple delimiters in the substring ... how do I modify the query ?

Thanks

With CTE .... in sql 2000 gives me a syntax error...any other way of doing this ?

Server: Msg 156, Level 15, State 1, Line 13

Incorrect syntax near the keyword...

How do I import the text file into 2 different tables using SSIS .

The consistent data into 1 table and the other inconsistent data rows into a different table .

those are the columns

a b c d e f

a b c d e f

a b c d e f g h

a b c d e f

a b...

Apparently I wouldn't have asked if I wanted to import into 1 column 🙂

columns are

My SSIS package extracts data from the database and dumps it into a textfile with timestamps.There is job which runs this SSIS package every hour.I have to mail each of...

Can you plz elaborate on the process.

Thanks

Issue has been resolved.

Thanks

Yes under sql agent . I believe with admin rights....Want to verify about how to check if the sql agent is running this job with admin rights ?

Thanks

Under file system.The package is running on the server .

I asked since UI is not an option as far as I am concerned.

Thanks

Suppose this is my stored procedure

CREATE PROCEDURE [dbo].[usp_test]

AS

select * from emp

GO

How do I export the results to an excel file with the name of the excel file changing every...

How do I check if the proxy user has the necessary permissions / privileges

Thanks

Exactly 1 column(datecolumn).

The output I need from a t-sql query is in this format .

Datecolumn ...