Viewing 15 posts - 2,131 through 2,145 (of 3,738 total)
Koen Verbeeck (11/14/2011)
What datatype has the numeric column in the SSIS dataflow?
Converting to a Unicode String [DT_WTSR] in a Data Conversion Task.
Since I posted this believe that it has something...
November 14, 2011 at 10:00 am
I did not come up with a solution, I had a question another question that was not important.
I believe that the best solution is to use Excel in this case.
Currently...
November 12, 2011 at 3:41 pm
mark 38539 (11/11/2011)
Not trying to sell software because I get nothing out of it, but if you need to do anything complex with excel use cozyroc.
What I'm talkig about doing...
November 12, 2011 at 10:59 am
Found answer, post removed.
Thanks.
November 12, 2011 at 10:34 am
Do you mean set the 64 Bit property to False on the Connection or what?
Thanks.
November 12, 2011 at 10:13 am
Thanks.
I'm dealing with 64 bit machines which could be a big part of my problem.
I noticed that CozyRoc has an Excel Connection
Manager that is supportive of 64 bit Operating...
November 12, 2011 at 9:58 am
kramaswamy (11/10/2011)
I tried this, and it worked fine for me:
@[User::TempCreatedFilesFolder] + @[User::OutputFile] + "_" +
(DT_WSTR,4)DatePart("yyyy", GetDate())
+ "_" +RIGHT("0" + (DT_WSTR,2)DatePart("mm", GetDate()), 2)+ "_"
+RIGHT("0" + (DT_WSTR, 2) DATEPART("dd",...
November 10, 2011 at 3:10 pm
:unsure::crazy:
kramaswamy (11/10/2011)
You're getting a truncation error because of this:
(DT_WSTR,2)DATEADD("day",-1,GETDATE())DATEADD return type is DATETIME. DATETIME is considerably longer than two characters.
Try this instead:
(DT_WSTR, 2) DATEPART("dd", DATEADD("day", -1, GETDATE()))
Unfortunately I get a...
November 10, 2011 at 2:19 pm
Iulian -207023 (11/10/2011)
But look what I found here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=124332
It seems that the SSMS 2005 does not show the DTS package logs but you still...
November 10, 2011 at 2:14 pm
I'm try to get yesterdays Date in an SSIS Expression and I keep getting syntax errors.
With all of the people that have subscribed to this post I thought that someone...
November 10, 2011 at 12:59 pm
John Mitchell-245523 (11/10/2011)
Instead of GETDATE()-1, try DATEADD("Day",-1,GETDATE()).John
Is this what you meant?
@[Dest_Dir_Deploy] + @[Dest_File] + "_" +
(DT_WSTR,4)DatePart("yyyy", GetDate()) +
"_" +
RIGHT("0" + (DT_WSTR,2)DatePart("mm", GetDate()), 2)+
"_" +
RIGHT("0" + (DT_WSTR,2)DATEADD("day",-1,GETDATE()), 2) + ".xlsm"
I get...
November 10, 2011 at 11:46 am
I get todays date from the expression listed below.
C:\SSIS\TXQuoteActivity\Deployment\FormattedTXQuotes_2011_11_09.xlsm
I tried altering it to GetDate-1 to get the Date to be 2011_11_08 but I got an error.
@[Dest_Dir_Deploy] + @[Dest_File] + "_"...
November 9, 2011 at 2:29 pm
John Mitchell-245523 (11/9/2011)
November 9, 2011 at 9:33 am
GSquared (11/8/2011)
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\SSIS\TXQuoteActivity\TXQuoteActivity.xlsm;Extended Properties="Excel 12.0 Xml;HDR=YES";
(You have the file extension as "xlsm". I'm used to "xlsx". Is that a typo, or is...
November 9, 2011 at 8:37 am
Koen Verbeeck (11/9/2011)
Are you using SSIS 2005 or 2008?I can use the Excel connection manager for Excel 2007 without a problem.
Unfortunately I'm using SSIS 2005.
I started out using the connection...
November 9, 2011 at 7:36 am
Viewing 15 posts - 2,131 through 2,145 (of 3,738 total)