Viewing 15 posts - 46 through 60 (of 68 total)
I made some test data for example of what I mean:
SET NOCOUNT ON;
GO
USE tempdb;
IF OBJECT_ID('dbo.demo') IS NOT NULL
DROP TABLE demo;
GO
CREATE TABLE dbo.demo
(
wage...
September 7, 2011 at 9:57 am
Well, it wasn't the simplest CASE statement ever, but joining the table twice did the trick. thank you.:-D
June 2, 2011 at 2:23 pm
I opened the file in notepad to see the delimiters. Here are the top 5 rows:
title,area,month,lausemp,lausunem,lauslf,lausrate,laus_sw,lauscalc,curyear
Minnesota,ST270000,1,2711426,219041,2930467,7.5,0,7.70E+25,2011
Minnesota,ST270000,2,2728138,217404,2945542,7.4,0,7.70E+25,2011
Minnesota,ST270000,3,,,,,0,7.70E+25,2011
Minnesota,ST270000,4,,,,,0,7.70E+25,2011
Minnesota,ST270000,5,,,,,0,7.70E+25,2011
I hope this is what you were looking for.
March 30, 2011 at 9:45 am
Jeff Moden (3/28/2011)
What does the actual file look like for those 5 rows you gave an example of?
That is a copy and paste of the actual file above. Where there...
March 30, 2011 at 7:09 am
Why couldn't I found this two weeks ago when I was nearly in tears over this?! OMG thank you for this.
Amy
March 22, 2011 at 11:31 am
I deleted the file task, and re-inserted one. now it works(?).
Back to the task of building an expression to run package even if file does not exist.
March 9, 2011 at 10:34 am
JeridA (3/9/2011)
If you look in the Error window you can probably get more info. View, Error List
0 Errors, 0 Warnings, 0 Messages. Just in output it says "task failed"....
March 9, 2011 at 10:23 am
I don't know what happened. now the drop test doesn't work at all. I does drop the file, but turns red and Execution Results says: Task drop test failed. Not...
March 9, 2011 at 9:38 am
One more question: Is there a way to make the drop file conditional? As in, "If exists, drop file". If the file is not already in the folder, I get...
March 9, 2011 at 7:46 am
JeridA (3/8/2011)
quote]
I feel just a little ridiculous for not having realized this. My mind was set around having to...
March 8, 2011 at 2:23 pm
JeridA (3/8/2011)
Little unsure what you're doing... drop a SQL table?
Jerid,
I am using an Execute Sql Task (which is originally what I posted in the forum for help before being...
March 8, 2011 at 12:41 pm
JeridA (3/8/2011)
You need to use the Data Conversion object to convert.
Yes, I went back to that, and saw that I had to map "copy of [column]" to output. Very happy...
March 8, 2011 at 12:15 pm
JeridA (3/8/2011)
Is the source data in an Access or SQL Server table?
The source data is a SQL Server Table. The destination is an Excel file.
OK, I have now figured...
March 8, 2011 at 11:50 am
HowardW (3/8/2011)
March 8, 2011 at 10:40 am
I'm using a Microsoft.Jet.OLEDB.4.0 as the connection manager to move the data into an Excel file, but now when I chose the file, I get this:
TITLE: Connection Manager
------------------------------
Test connection failed...
March 8, 2011 at 9:58 am
Viewing 15 posts - 46 through 60 (of 68 total)