Viewing 15 posts - 6,496 through 6,510 (of 11,676 total)
sameer.kambli (8/29/2012)
Search MSDN online for Schema.ini and OLEDB Text Driver!!
I did. Nothing pops up.
August 29, 2012 at 1:59 am
sameer.kambli (8/29/2012)
though what i said earlier is not related to SSIS, behind the scenes SSIS uses Schema.ini and OLEDB text driver for reading flat file.
Do you have any resource for...
August 29, 2012 at 1:44 am
sameer.kambli (8/28/2012)
Hi Check out Attchement!!
What does this have to do with the schema.ini and the OLE DB Text driver you mentioned earlier?
@asranantha: schema.ini and the JET OLE DB provider allow...
August 29, 2012 at 12:02 am
Great question Wayne, thanks.
August 28, 2012 at 11:57 pm
mp83399 (8/28/2012)
exec testing.dbo.proc_TEmptest ?,?
(The '?' are the place holders)Now map these two question marks to the SSIS variables...
August 28, 2012 at 11:40 pm
abhilasha.yera 97854 (8/28/2012)
I'm trying to Install the Adventure Works DW 2008R2 and It says it a fatal Error and it cannot install it My system is Windows 7...
August 28, 2012 at 11:33 pm
You can use parameters there - example[/url] - but this can be a bit buggy. The easiest way, in my opinion, is to use a string variable and construct your...
August 28, 2012 at 2:56 pm
f_ernestog (8/28/2012)
Is there way...
August 28, 2012 at 2:41 pm
Hugo Kornelis (8/28/2012)
I've raised a documentation bug for this issue: https://connect.microsoft.com/SQLServer/feedback/details/759944/documentation-of-isdate-function-incorrect
Voted +1.
(and indicated I could reproduce it)
Very interesting question, thanks.
August 28, 2012 at 3:42 am
Well, you can't find the inserts without loading the destination table, as the lookup needs something to compare the data to.
If your source and your staging are SQL Server tables...
August 27, 2012 at 11:38 pm
As long as the length is not more than 4000 characters, DT_WSTR shouldn't be a problem. Varying length is not an issue.
DT_NTEXT is BLOB (or CLOB, not sure) data, so...
August 27, 2012 at 11:33 pm
Saga... (8/27/2012)
Main objective is to find duplicate db's...... and out put is perfect..... which I am looking for....
Can you please help wi
I asked two questions. You didn't answer any...
August 27, 2012 at 5:30 am
Nomvula (8/27/2012)
thanks for the quick response.is there a code that i can use to convert .tif to jpg dynamically for displaying purposes.
No idea, this is a SQL Server forum 🙂
August 27, 2012 at 5:07 am
According to this page, .tiff is not supported by SSRS.
August 27, 2012 at 4:00 am
Maybe you can give some sample data for table DBINVENTORY.
Why is it OK for some servername-dbname pairs to have 2 rows as output and for others isn't?
August 27, 2012 at 3:56 am
Viewing 15 posts - 6,496 through 6,510 (of 11,676 total)