Viewing 15 posts - 46 through 60 (of 69 total)
You should be able to get the ODBC driver from Progress. Install it on whatever machine(s) the SSIS packages will run.
If you are running on Windows 64bit,...
January 17, 2008 at 12:45 pm
In the SSIS world, the DT_DBTIMESTAMP is a SQL DATETIME. They are one in the same.
Have you tried a data conversion task (between the data source and the destination)?...
January 17, 2008 at 12:27 pm
None of the native ODBC drivers will work with Progress. You need to contact Progress to get one.
When you do, be prepared to deal with data type mismatches and...
January 17, 2008 at 12:23 pm
Granularity has more to do with the fact tables than it does the dimension tables.
The point behind designing dimensions is to make them conformed so that you can use it...
January 17, 2008 at 11:49 am
The Fledgling SQL Developer
Once upon a time, there was a fledgling SQL developer. He was alone in his small-company world and wondered when he would ever find someone to...
October 2, 2007 at 1:00 pm
Thanks for the feedback. I've actually started using Datiris Profiler. It's fairly light on the features, but it does what I need and it's not as expensive as others I've...
September 21, 2007 at 5:45 am
In the advanced properties of the flat file connection manager, there is an option to "Suggest Column Types".
If you have enough memory, tell it to read the max number of...
August 30, 2007 at 3:13 pm
Is there a reason you are dropping and recreating the table? Why don't you leave the table there and just TRUNCATE it?
I'm always hesitant to turn off validation if I...
August 30, 2007 at 1:19 pm
I can appreciate your frustration. SSIS is a pretty big blackbox that takes some time and experience to be familiar with it...
In MSDB, make sure your connection account has...
August 30, 2007 at 8:49 am
Is there a reason you are using the ActiveX Script component, instead of the Script Task component? Is it a previously coded ActiveX script, or new?
The following article (http://technet.microsoft.com/en-us/library/ms137525.aspx)...
August 30, 2007 at 8:18 am
Try redirecting the flow of the second derived column task, as well. It sounds like this new file has a value that is failing the second derived column task.
Have you...
August 27, 2007 at 2:13 pm
SSIS only allows VB.NET.
According to this interchange on the MSDN forums (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=68553&SiteID=1), there won't be native C# scripting in C#. SSIS leverages the VSA environment, which only supports...
August 27, 2007 at 2:05 pm
Here are a couple of things you can look at before changing the timeout (which I honestly can't help you with - have you tried BOL?):
August 27, 2007 at 2:01 pm
There is a pretty good website that provides some free, basic SSIS training videos (there is some other goofy stuff there, as well, but some good SSIS stuff):
August 27, 2007 at 1:52 pm
You may need to add a data conversion task inbetween your source and destination to explicitly convert the values.
SSIS doesn't like to do implicit unicode to non-unicode data types. (It...
August 27, 2007 at 1:47 pm
Viewing 15 posts - 46 through 60 (of 69 total)