Viewing 11 posts - 301 through 311 (of 311 total)
Well, this reply may be disappointing as well, but have you tried the "Suggest Types..." option in the "Advanced" panel of the connection manager?
Peter
January 16, 2008 at 1:06 pm
Copy the DTSX files from the remote server into your project directory. Open the project and then choose 'Add existing item...'. Then select all the files (using the CTRL-key) you...
January 15, 2008 at 11:09 am
Last year there was a series of articles titled "XML Workshop" published at SSC by Jacob Sebastian. Lots of interesting examples of how to read data from the XML datatype....
January 15, 2008 at 9:26 am
Turn the 'keep identity' checkbox off (it's the same as the FastLoadKeepIdentity in the properties dialog box). If 'keep identity' is checked, NULL values will be inserted into the identity...
January 11, 2008 at 6:28 am
Check if the property FastLoadKeepIdentity is set to False.
Peter
January 11, 2008 at 6:05 am
If you're using a data flow task to pick up the excel file and throw into a db, set the DelayValidation property of the data flow task to True. If...
January 11, 2008 at 5:24 am
Use the property "AgentJobId"
Peter
January 5, 2008 at 5:16 am
As far as I can remember, there's no 64-bit provider for Oracle. Running the package in a 32-bit environment, as you did, solves the problem.
Peter
December 31, 2007 at 1:00 pm
Oops,
I inserted some placeholders in the expression surrounded by less- and greater then characters. Probably disappeared as invalid HTML-tags.
The expression should be something like
Expression="SELECT fields FROM table-prefix" +
RIGHT("0" +...
December 31, 2007 at 9:35 am
In the data flow task, create a string variable User::varCommand and set the following properties:
EvaluateAsExpression=True
Expression="SELECT " +
RIGHT("0" + (DT_WSTR, 2)MONTH(GETDATE()), 2) +
RIGHT((DT_WSTR, 4)(YEAR(GETDATE())), 2)
(Replace )
Now use...
December 31, 2007 at 6:50 am
I 've built a little test report with this query and got the following error:
[rsCompilerErrorInExpression] The CommandText expression for the query ‘Test’ contains an error: [BC30201] Expressie wordt verwacht. (An...
December 31, 2007 at 5:36 am
Viewing 11 posts - 301 through 311 (of 311 total)