Viewing 15 posts - 16 through 30 (of 100 total)
Thanks for the reply, i think you are correct. I donot have access to the datasource and the people who do donot seem to know how to change the view.
I...
May 7, 2008 at 11:11 am
Yes i do have delay validation set to true. I made a mistake above the connection for the file task is ste by a variable their is an option isDestinationPathVariable...
March 13, 2008 at 7:05 am
The metadata for the "Server" source has changed. Looks like a change to the datatype has happened at source. edit the oledb source and check the column mappings. You may...
August 16, 2007 at 4:26 am
Ok. Create a variable called sqlstatment at package level. Click on the variable and get propertiesfor it. Set the evaluate as expression to true. Click the ... on expression and...
August 16, 2007 at 4:06 am
I think you have difficulty understanding the difference between the task flow components and the data flow componenets. If all you need to do is move data from a source...
August 16, 2007 at 2:24 am
Ask for access to the MSDB using the db_dtsAdmin Database Role
Microsoft still use the dts naming although we now call it ssis. i.e the roles db_dts and SP's are sp_dts_...
August 15, 2007 at 9:03 am
Firstly i am supried that exp works without appending single quotes around the date.
If you do get resultset you have to store it in a variable of type object (you...
August 15, 2007 at 8:54 am
Typical. Havent used db2 provider but used Lotus Notes and the same you cannot export a column over 256 characters unless you logon on to ibm and purchase their odbc...
August 15, 2007 at 4:35 am
Looking at the error again i think it maybe a different problem. On the access mode under custom properties try changing to open rowset (dont use fast load) this will...
August 14, 2007 at 9:13 am
What ed said maybe right. Although your output data type is correct your input(external) datatype may not. ssis previews 100 records and determines what datatypes to set for the external data...
August 14, 2007 at 9:03 am
I refered to a transfer sql Objects task but will also work with a transfer sql database task
August 14, 2007 at 7:23 am
Try this
Create table for connections
coloumns:-SourceServer,SourceDatabase,DestinationServer,DestinationDatabase
now in ssis
Sql Task to select from connections table put query results to a variable (object type)
then precedence constaraint to a foreach loop container enumarator type Ado...
August 14, 2007 at 7:19 am
Do yu have more than one instance of SQL running? Use Server\instance.
August 14, 2007 at 3:33 am
you donot need the copy coloumn transformation(it wil make another copy of the column). What you do is edit you sorce oledb and select columns on the left. Just tick...
August 14, 2007 at 3:10 am
Hi tim
Not sure what the problem with this error is. I think it is something to do with your DB" database not making that coulmn available for export. Not sure...
August 14, 2007 at 3:04 am
Viewing 15 posts - 16 through 30 (of 100 total)