Viewing 15 posts - 1 through 15 (of 15 total)
Most probably is an SSIS job which would be loading the table and you could lookup the source connection in the project file to find the source data system, or...
November 25, 2015 at 9:21 pm
not very clear by what you mean, but i'd guess the error is to do with not having access to the master schema to create a table and the need...
November 25, 2015 at 9:17 pm
Option 1
I guess you could design a package with various scenarios i.e input file as excel/csv and union them to a temp table before inserting the records where you...
March 26, 2014 at 8:15 pm
Got this working ... not sure if i did anything different ...
the data viewer still dosen't pop up also i noticed the export leaves about top 400+ lines blank...
March 27, 2013 at 7:04 pm
not sure if this is the exact outcome you were hoping for but i would declare a variable for the file name, use file system task to move the file...
March 27, 2013 at 3:31 pm
Thanks Phil,
i thought so the warning wasn't relevant ...
i do have a data viewer in place that is just before the data exports to excel ... surprisingly all...
March 27, 2013 at 3:23 pm
Just confirm if scantime is date or date time ???
also if scantime is already date, why convert it again..
March 25, 2013 at 10:08 pm
Spot on Veerbeek..
i have come across date issues myself when using excel as a data source ... apparently is not best practice using excel (but thats a different story)
as...
March 21, 2013 at 7:44 pm
The Hyperlink function in excel is the same function as action function(SSRS 2008) you can use it to goto a certain section of the report which has detailed data...
March 21, 2013 at 4:42 pm
is there a particular reason you want the date to appear as 30-sep-2009 in the database???
if not suggest you should be able to use a normal data conversion to...
March 20, 2013 at 6:35 pm
Select a certain cell or maybe insert a new one i.e "page 2"
right click on it and goto text box properties and select action ...
you will have 3 options to...
March 20, 2013 at 6:16 pm
Lynn Pettis (1/14/2013)
Or:
DECLARE @start_of_day int = 15156;
select DATEADD(dd, @start_of_day, '19700101');
i guess this works .... thanx 😀
January 14, 2013 at 5:18 pm
you could use the import export data wizard on SQL server .
or if you do not have it installed ..
right click on the database>tasks>import data. follow the steps...
November 28, 2012 at 7:55 pm
Just a note when working with datetime stored as number/int...
check if it is stored in seconds or milliseconds .. i.e if it is 10 characters or 13 characters...
code...
November 27, 2012 at 4:49 pm
Viewing 15 posts - 1 through 15 (of 15 total)