urgent help: issue while loading flat file .


 

i have load flat file sql server table using ssis.

the destinationn table has pre assigned datatypes specific length.

when load flat file takes ssis assigned datatypes , gives me truncation error destiantion datatypes of smaller length.

please how sort out?

how can assign destination table datatypes are  instead of ssis datatypes.

sam

double click flat file connection manager, go advanced panel, change each columns' data type need. see warning in flat file source, double click flat file source , warning automatically fixed.

 



SQL Server  >  SQL Server Integration Services



Comments

Post a Comment

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

having same error microsoft.azure.documents.documentclientexception: message: {"errors":["owner resource not exist"]} , scenario. when deployed webapp azure , try document docdb throws error. docdb exists in azure , contains document looking for. weird local machine(running vs) works fine. i'm using same settings in azure , local. have , idea this. thanks Microsoft Azure  >  Azure Cosmos DB
Read more

Dataset not seen?

Image
i not see dataset in existing ssrs report? there solution explorer in right section left site tool box. best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql consulting: large scale of database , data cleansing remote dba services: improves ms sql database performance sql server integration services: business intelligence SQL Server  >  SQL Server Reporting Services, Power View
Read more

Performace

if 1 knows steps  check  , analyse performace issues memory please provide information? how confirm tha issue not memory issue ? http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/08/24/troubleshooting-the-sql-server-memory-leak-or-understanding-sql-server-memory-usage.aspx http://blogs.msdn.com/b/karthick_pk/archive/2012/06/15/troubleshooting-sql-server-memory.aspx best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql blog: large scale of database , data cleansing remote dba services: improves ms sql database performance SQL Server  >  SQL Server Database Engine
Read more