Insert Values in destination table in SSIS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Insert Values in destination table in SSIS

Author

Topic

lynanee
Starting Member

2 Posts

Posted - 2011-01-25 : 12:06:26

I am building SSIS package and have to load values into the columns using sql command on the destination OLE DB. When I click on OK, i receive an error message which says that the query cannot be parsed. Does anyone know how best to do this? Thanks!!!

Here's the sql code that I used:

INSERT INTO Groups(Group_Key,Expired_Flag,Effective_Date,Expired_Date,Group)
VALUES ('BU',0,'2000-01-01','2099-12-31',Business Unit')
INSERT INTO Groups (Group_Key,Expired_Flag,Effective_Date,Expired_Date,Group)
VALUES ('CONT',0,'2000-01-01','2099-12-31','Contractor')
INSERT INTO Groups (Group_Key,Expired_Flag,Effective_Date,Expired_Date,Group)
VALUES ('Non-Bu',0,'2000-01-01','2099-12-31','Non Business Unit')
INSERT INTO Groups (Group_Key,Expired_Flag,Effective_Date,Expired_Date,Group)
VALUES ('UNKN',0,'2000-01-01','2099-12-31','Unknown')

SELECT Group_Key, Expired_Flag, Effective_Date, Expired_Date, Group
FROM Group

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2011-01-25 : 15:07:30

When you copy and paste the exact SQL from the SQL task in SSIS into Query Analyzer--does it parse there?

This is pretty easy debugging if you do the basic things..

but your error is quite visible
VALUES ('BU',0,'2000-01-01','2099-12-31','Business Unit')

missing a single quote before Business Unit in the 1st insert.

Poor planning on your part does not constitute an emergency on my part.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources