Viewing 15 posts - 1 through 15 (of 144 total)
This isn't my database design, however, the actual database itself is in 1st Normal form. To get a quick and easy example I posted this knowing I'd have to...
January 9, 2017 at 7:41 am
Thanks! This looks like it will do the trick. Just need to incorporate it with the actual table structure in the database.
January 9, 2017 at 7:38 am
That won't work because the main dataset that the report is based on is from the results of a stored procedure and I just need one value from that result...
February 5, 2013 at 3:24 pm
Yes, that is what it appears to be. Interesting that if you use other quantities it sometimes returns the correct values. For instace, if you change the data...
December 20, 2011 at 2:43 pm
So when running the query I provided you each get 7 records returned?
It could be an issue with the version of SQL. I need this to work...
December 20, 2011 at 1:07 pm
The query isn't failing. It is just returning more records that it should. It returns 8 records but there are 14 records with a tier of A1. ...
December 20, 2011 at 10:57 am
I reread Tom's post and went in and removed the environment variable config and am just setting the DB Connection in the job and now it is running and finding...
August 4, 2011 at 10:43 am
I have specified the configurations in SQL and the connection to the Database with an environment variable. For the step in SQL Server Agent I have changed the data...
August 4, 2011 at 10:14 am
No, I didn't find an answer to it. I don't think what you found is the answer because like I indicated there are some 97 Excel files that do work...
March 17, 2011 at 4:45 pm
I am trying to connect to some 97-2003 Excel files but when that didn't work because of the error I was getting I looked at some 2007 files as well...
March 11, 2011 at 3:38 pm
Here is the expression:
@[User::DataLoadDirBegin] + (DT_STR,4,1252)YEAR( DATEADD( "dd", -1, GETDATE())) + @[User::DataLoadDirEnd] + RIGHT("0" + (DT_STR,4,1252)MONTH( DATEADD( "dd", -1, getdate())),2) + "-" + SUBSTRING((DT_STR,4,1252)YEAR( DATEADD( "dd", -1, getdate() )), 3,...
March 10, 2011 at 3:09 pm
I created an Excel connection and then set the ExcelFilePath Expression to be what I wanted for the file.
For the Excel source I then chose the connection but when you...
March 10, 2011 at 12:41 pm
Yes, I did select the correct one. In fact, when it didn't work on the one it was supposed to I tried all of the Excel versions but got...
March 10, 2011 at 8:11 am
Discovered something interesting this afternoon. The files are saved as 97-2003 Excel files and for these particluar files it doesn't matter what I do, I get the errror indicated...
March 9, 2011 at 4:08 pm
The file structures are all the same. It also doesn't seem to matter on these particular series of Excel files because I tried it by linking directly to the...
March 9, 2011 at 1:00 pm
Viewing 15 posts - 1 through 15 (of 144 total)