TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
suresh
NA
293
0
SSIS DataTransformation
Dec 1 2011 12:06 PM
hi,
i have problem with exporting records using SSIS, when i export record from one table to anthor table(two different servers) using SSIS so many records are missing.
Ex:I have source table with 200 records , but i am getting into the destination table only 120 records...so remaining 80 records are missing...
This ssis will run by the sql job for every 30 minutes.....
Daily i am missing the records..
the source table and destination table columns and data tyes are same.
1)call_Date datetime
2)originalcalledpartynumber varchar 50
3)callingpartynumber varchar 50
4)duration varchar 6
5)DateTimeOrigination varchar 50
but i am getting some warning messages in the SSIS when i run it manually like this
[OLE DB Destination [385]] Warning: Truncation may occur due to inserting data from data flow column "originalcalledpartynumber" with a length of 8000 to database column "originalcalledpartynumber" with a length of 50.
[OLE DB Destination [385]] Warning: Truncation may occur due to inserting data from data flow column "callingpartynumber" with a length of 8000 to database column "callingpartynumber" with a length of 50.
[OLE DB Destination [385]] Warning: Truncation may occur due to inserting data from data flow column "duration" with a length of 50 to database column "duration" with a length of 6.
[OLE DB Destination [385]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "DateTimeOrigination" needs to be updated in the external metadata column collection.
please give me some solution,thanks in advance.
Reply
Answers (
2
)
How to create stored procedure to insert nvarchar data type?
Can we get records in a single row