I saved the first two rows to a text document. Opened with excel and noticed the number of columns in each row are different.

This might present a...

I have a cool function that I use for just this reason:

Create a table function:

CREATE FUNCTION [dbo].[ParseValues]

(@String varchar(8000),

@Delimiter char(1) ...

I tried this using VS 2005/2008. After renamed a destination table and disabled, they ran. Are you positive you are not using the tables in another task that...

I would wait till your kids are around 10 to let them see it...

How are you accessing the data, are you importing and if so, is it set to import as Unicode?

I don't understand the question...

The way variables are handled depends on what connection type you are using.

Variables inside OLE are referenced using ?

Variables inside ADO.NET are referenced using the @VariableName set-up in Parameter mapping.

The Execute SQL task is better in my experience than Data Flow tasks, dynamic sql is just a method for achieving what he wants to do in the Execute SQL...

My vote is with Da-Zero. Dynamic SQL in Execute SQL tasks. I think these run more efficiently than Data Flow tasks, especially if you will be working with...

Here is one way of doing it:

DROP TABLE #Temp

DECLARE @X int

SET @X = 1

CREATE TABLE #Temp (Phone varchar(17) null)

WHILE @X < 101

BEGIN

INSERT INTO #Temp(Phone) select Phone from People where Phone...

When things are going bad and I am having work issues, I kick it into overdrive and don't quit till I get the problem solved.

When I can't figure something out,...

The SQL Server Import and Export Wizard can copy data from a source to a destination very fast and it is relative easy to use.

If you meant SFTP, SSIS does not support this. I had to call third party software (PSFTP, the PuTTY SFTP client) from the SSIS package after I generated the...

Try this:

SELECT A.Nbr_Orders,

A.CustID,

Customers.Name1

FROM

(SELECT COUNT(Orders.Orderid) as Nbr_Orders,

Orders.Custid as CustID

FROM...