Someone posted this answer in previous post on your error.

Here's below answer.

Hi the below steps might help to solve issue more quickly.

1.Use the OLE DB Destination.

2.Use the "Table or...

SELECT

t.NAME AS TableName,

s.Name AS SchemaName,

p.rows AS RowCounts,

SUM(a.total_pages) * 8 AS TotalSpaceKB,

...

As with My data I created one file and table Here I am attaching both.

If you create package and It will throw you error at row 2.

Yes It will convert it to 0. But I had the same issue and I used derive column with above expression and converted empty space into NULL and then I...

The column after "A" is "" that means it's empty so SSIS takes empty space as string.

You are getting error because your destination column is Integer.

You need to...

This error you are getting has lots of possibilities. Is your file has text qualifier??

If yes then you might have " " empty space in between and your destination column...

I found out the problem.

In my destination database that empty space in column is int. so SSIS can't take empty space in " " as int. thats why I...

I am getting error at flat file connection.

[FF_SRC - Raw Data File [27]] Error: Data conversion failed. The data conversion for column "Time-UTC-Sec" returned status value 2 and status...

select convert(char(20),cast('1/1/2010 8:30 PM' as datetime),120)

Result: 2010-01-01 20:30:00

I can use this query in SSMS but I dont know how to use this query in SSIS.Which convert AM/PM format in...

Thanks Sean for your reply.

the raw files which has columns CreationDate, StartDate and EndDate are by default in string. Which has format 1/1/2010 12:00:00 PM.

Now I want to...

Actually in my case I had Data Dictionary. So I used to get all data types from there. so

Cause At my work We were loading first client data to...

Here is the script to copy table structure from temp to target.

CREATE TABLE TagetTableName

AS

SELECT TOP 0 * FROM TempTableName.

This error you are getting because your target table has column length different than the temp table.

Make sure you have target table structure same as temp table.

I used...

If any way I can create variable in SSIS and change table name???

The reason is that data coming that are very large more than billions of records for each client.

So I can't put it in same table.

I created SSIS packsges which...