Here is a function that you can use to count the tabs in a records:

--create this function first

CREATE FUNCTION [dbo].[ufn_CountChar] ( @pInput VARCHAR(1000), @pSearchChar CHAR(1) )

RETURNS INT

BEGIN

RETURN (LEN(@pInput) - LEN(REPLACE(@pInput,...

Hello Here is one way.

Create Flat file Connection in SSIS setting the layout for 1Col

Create SQL Table:

CREATE TABLE dbo.Process_Table (

ID int identity(1,1) not null,

Column1 varchar(5000) null,

Nbr_Fields int null)

Import the whole...

Never used sparse columns in my SQL experience, do any developers here use them frequently?

Who in their right mind would use curse words in an interview?

I have interviewed people the last few years and this is not the way to get a job.

Also, regardless...

Use ChrisM@Work solution as it is clean and trim...

Thanks Sean your solution worked like a charm.

I will add a little detail to the previous post:

EXECUTE SQL TASK - POPULATE three variables based on counts:

@NbrRecords_in_TableA = 0 (or the count)

@NbrRecords_in_TableB = 0 (or the count)

@Records_Exist =...

Charindex is how I would roll...

I would look into the settings around the ODBC driver or play around with different SQL drivers. Of course the native sql driver is probably the best way to...

Interesting problem. Agree with Koen (previous poster) that dts is using a script to connect to the linked server.

All the posters here believe its a connection issue to the...

Not sure this is going to help...But I developed applications in MS Access and what you need to consider trying to track what happens and where is these reports are...

Please tell me the vendor is not Red Gate Software...

If you are don't need to do it with a secure connection try this:

http://www.sqlis.com/post/Downloading-a-file-over-HTTP-the-SSIS-way.aspx

All you need to do is put the connection information in and where you want to download to.

SSIS does not support HTTPS so you don't need the connection manager.

I was...

OK here is what we do. Use Event Handler for the package to send email using sql server (if it is configured):

Here is the code you can paste into...