Viewing 15 posts - 181 through 195 (of 1,346 total)
Discusses Issues with money.
There are rounding issues with money and is probably not the best datatype to use in your scenario.
September 27, 2012 at 11:13 am
What your requesting is kind of unusual, and I can't think of an easy way to display 15 rows.
Would it be acceptable if you set the option on your group...
November 9, 2011 at 8:32 am
I wouldn't say your table has bad data.
The datatype is varchar, which indicates it can hold al lot of characters other than Numbers.
Check your table for non numeric values.
SELECT *
FROM...
November 9, 2011 at 8:29 am
What is the datatype of your time column?
How are you displaying time?
If you are using a datetime, or time column it implicitly orders correctly.
You have to cast it to display...
August 23, 2011 at 9:38 am
yup.
or
DELETE TABLEX
WHERE TBXRefNo IN (SELECT DBZRefNo
FROM DATABASEZ.DBO.TABLE1
WHERE...
August 23, 2011 at 9:29 am
I assume your already using a transform task to cast it into a date.
If not add a derived column transform between your source and your destination.
for Col095 Replace Col095, and...
May 4, 2009 at 2:01 pm
Certainly that works if the file does not show up within the allocated # of intervals, but what if the file is not the expected size?
Frequently we get files that...
April 1, 2009 at 3:05 pm
Does File.Exists Evaluate to true even if the file is still copying?
If a file is large it can take several minutes to copy, and if it picks it up too...
March 31, 2009 at 9:08 am
Set Rows per transaction in the Oledb destination task
Maximum Insert Commit Size.
If your database Recovery model is Simple, OR bulk logged.
You can also set the Tablock Option and the...
March 20, 2009 at 5:04 pm
The Idea here is if you delete data in small enough batches it will not lock the table.
If necessary, select out the data into an archive table.
Then for example delete...
March 17, 2009 at 10:33 am
Double check in your flat file destination that the data type for that column is a String.
March 13, 2009 at 10:16 am
Nerds
Nerds!
Nerds
Nerds!!
Nerds!!!
Ha Ha :w00t:
Just kidding, I'm here with ya!!
Does not compute
February 24, 2009 at 2:26 pm
In your Data flow task
Put a derived Column Transformation between your file source and table destination.,
Add a column using the source column you want to change.
and put an expression,.
[Column 0]=="F"?...
February 20, 2009 at 12:49 pm
Is this being done in SSIS, or T-Sql?
I'm confused because of the forum you posted to.
try to divide by 100.00 sometimes that fixes the issue.
February 19, 2009 at 11:25 am
Sanjeev Jha (2/19/2009)
February 19, 2009 at 11:20 am
Viewing 15 posts - 181 through 195 (of 1,346 total)