Help Reading From 3 Party Source
Apr 9, 2008Hi,
I have a commercial data source 3 party one for me to extract data from , i have been provided the exe and the DLL how i can use this in SSIS as a datasource please let me know.
Thanks,
ADVERTISEMENT
3rd Party Source Control That Leverages VSS
Jan 5, 2004I noticed from this link:
http://www.aspfaq.com/show.asp?id=2495
There are four well known products that are used by medium to large size shops to help aid in change management of SQL Environments.
- AbaPerls
- DBGhost
- MSSqlExpress
- SQL Source Control
Does anyone currently use any of the above? Could you briefly explain your likes an dislikes and if you have reviewed any of the other options above when you had to make a decision as to which product to use?
Reading From A XML Source
Mar 22, 2006I am trying read certain attribute from a XML Source based on a particular attribute.
My XML source has the following Structure:<Database ID = "1" Source = "ABC" ></Database><Database ID = "2" Source = "ABC" ></Database><Database ID = "3" Source = "DEF" ></Database>.
I would like to fetch the list of IDs filtering upon Source = "ABC". (which should idealy give me 1,2)
I tried using the For Each Nodelist Enumerator By specifying the Enumeration type as Node and IDrect Input for the OuterXpathString as DATABASE[@Source="ABC"].
The for each loop fails giving the following error. Data is invalid. line 1 position 1.
Can anyone help me out with the same. Is there any other way around to obtain the required result?
Pranathi
XML Source Not Reading Any Records
Sep 19, 2006The problem started off as:
I have a webservice written in VB.NET that simply returns a System.Data.Dataset. I want to use the dataset in SSIS.
So i decided to do this:
Save the returned dataset returned by the WS to an XML file. so it is sitting there, and looks like a fully valid XML file
<?xml version="1.0" encoding="utf-16"?>
<DataSet>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Table">
<xs:complexType>
<xs:sequence>
<xs:element name="Name" type="xs:string" minOccurs="0" />
<xs:element name="SourceRecord" type="xs:string" minOccurs="0" />
<xs:element name="CombinedTitle" type="xs:string" minOccurs="0" />
......
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<NewDataSet>
<Table diffgr:id="Table1" msdata:rowOrder="0">
<Name>Member</Name>
<SourceRecord>99998</SourceRecord>
<CombinedTitle>Mr</CombinedTitle>
<CombinedFirst>Sample</CombinedFirst>
........
</Table>
</NewDataSet>
</diffgr:diffgram>
</DataSet>
I then use the XML source connection to connect to it. It sees all of the columns correctly, but when i run and put a watch on it, or try to output the results to a .csv file, no records come through.
Any ideas on why there aren't any rows comming through?
i'm using SQL2005 with no SP1
Reading Dates From An XML Source Adapter
Oct 30, 2007I am using an "XML Source Adapter" in an SSIS Package to try and load an XML file into a database table. But having trouble with a date field.
The XSD defines the field as:-
<xs:element minOccurs="1" name="DateTime" type="xs: string" />
The XML looks like this:-
<DateTime>12/31/2007 10:12:14.123</DateTime>
And the database table column is defined:-
[DateTime] [datetime] NOT NULL,
So in the Data Flow I have a "Data Conversion Transformation" converting [DT_WSTR] to [DT_DBTIMESTAMP].
However, when I run the package I get:-
Error: 0xC02020C5 at Load XXX File, Data Conversion 1 [13550]: Data conversion failed while converting column "DateTime" (15100) to column "DateTimeDT" (15422). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
So what how do I fix it?
I don't mind losing some miliseconds of precision, so I have tried configuring the error output of the Data Conversion for this field to "ignore failure" for "Truncation". But that seems to have no effect.
I'd be happy to change the XSD to:
<xs:element minOccurs="1" name="DateTime" type="xs:dateTime" />
But the "XML Data Flow Source" doesn't seem to support the dateTime data type.
Any suggestions appreciated. Thanks.
Errors Reading From An Excel Source
Nov 27, 2007
Hi,
I have an Excel spreasheet - the first column is text, the second numbers, the third a mix of the two. If I point An Excel Source at this in my data flow, it will import the first two columns without problem, but not the third: all cells containing text are being imported as nulls, but those containing numbers are imported just fine.
Even if the numbers are stored as text, they are converted into numbers at import and genuine text is still discarded. It's treated as if the entire column is numeric if there's just one numeric value in it.
I can get around this by creating a .csv or .txt file from the excel file, but that will add an extra layer of admin to this process and I'm tryuing to make it as seamless as possible
Reading From SSIS Flat File Source?
Feb 9, 2012I have a simple SSIS package -> It reads a local text file which has 10 rows of data ( id, name, telephone # ) and puts it into a table.
It uses the "SSIS Flat File source" to read and a "SQL Command" to insert into the table. I can see that it reads line by line and puts each line into one row in my table.
Now, my production data is over 5 GiG of mainframe data and it seems their data is arranged in some hierarchical form.. so the position or arrangement of data in that file is important.
I pulled the data using my package and as far as I can see , my SSIS package pulled one line at a time ( from the flat file) and pushed it into my table. For each row, I also created an identity column in my table to be able to identify the positional arrangement of the hierarchical data and then use relational mappings to suit our business needs.
In all of this, my assumption is -
"SSIS reads one line at a time, inserts to my table and goes down to the next line .
It does NOT read a snapshot of rows from the flat file so as to write them into the table using internal ordering methods based on that particular snapshot "
My question is .. is my assumption correct ?
Reading A Variable In A Script Taks Used As Source
Aug 28, 2006Hi,
I'm using a script task as source and I need to read a global variable.
I tried stuff I found on the internet, but they all use Dts.VariableDispenser.LockForRead(varName)
This gives an errero on 'Dts.' saying it can not resolve it.
Excel Source Not Reading Newly/appended Rows
May 2, 2007I am trying to ETL from excel source to SQL table. When I created the package my excel had certain number of rows. Later if I add (append) few more rows in the spreadsheet ... the ssis package (also in excel source preview) not reading the newly added rows. Suprisingly it is reading new rows if they are inserted in between existing rows.
Any idea why ?
Problem Reading Tab Delimited Flat File Source With Missing Tabs
Aug 3, 2005I have a tab delimited flat file with say 60 columns. All columns can have null values. The file contains a blank tab for nulls.
View 25 Replies View RelatedThird Party Tool
May 1, 2001Hi All,
I have to load data from from a text file ( approx 3-5 million rows) into a table .
I can use straight bcp with the format file , but the loading of data has to follow some business logic
Let me know if there are any third party tool to load the data instead of regular bcp
I have SqlServer 7.0 on Windows NT 4.0
Thanks in advance
3rd Party Software
Oct 13, 2005Does anyone know any software to backup single tables ? i recall one software that extracts the data into a text file called SQLinsert or something but wondering if they are others around ?
View 1 Replies View RelatedThird-party Tools For DBA
Apr 27, 2008hello,
what are some good db managements tools that are available? I installed Toad from Quest and the Red Gate's toolbelt but I haven't play with them yet. I would like to know what is the most useful tool to invest time in.
Thanks.
Third Party Software
Sep 12, 2007Hey guys I really need your help.
We've outsourced our software last year, and it really a big mess for us since that company has been clashed. Then it so happened that the system failed to function well. Our batch transactions was working about 56 mins.. that is 24 records. Then it happened that this time 28 records was finished for about an hour. Our business hour is 8 hours only. That's why we have a back log now. We also failed to validate transaction since it takes a lot of effort before we update the database. It's working before but as our database becomes larger there are many errors occur in our application. Majority is runtime error. Then it happened that now we cannot move on anymore. We are using SQL server 2000 with VB6.0 application. our server memory is 1GB. Do you think adding additional memory will solve our problem?
Thanks!!
Third Party Sql Tool
Jul 20, 2005I prefer to write SQL code, without graphical tools.Have third party Query Analyzer that has filter and sort abilities?Also I looking for SQL editor with Completion ability (like we know forprogramming lang),for assist me write more quickly.
View 1 Replies View RelatedUsing Third Party ADO .net In Script
Oct 24, 2006I am working on a SSIS package to move data between SQL2005 and DB2. I currently have the DB2 ADO .Net connector from DataDirect which works fine for connecting to the AS400. My question is that I am working on a script transformation and I want to be able to use the Connection already created in the package their.
I can set it up just fine using the properties for the script, but there appears to be no way to create SQLCommands and connections unless I reference the DataDirector DLL in the script, which requires adding it to the GAC and the Framework folder.
I am just wondering if this is the correct way to go about this or if there are any other recommendations. Please let me know if I need to supply more information.
Thanks,
Chris
Third Party Backup Programs
Feb 27, 2002Currently we are using SQL Servers Backup utility to backup our databases to disk and then the files to backup tape during a nightly backup.
The time it takes for the backups to disk to complete for the databases is becoming prohibitively long and performance problems on the DB server are manifesting.
I am interested in other solutions. However, the propaganda listed at the various companies sites are less than insightful.
I was wondering if anyone used a third party Agent like Brightstor Enterprise SQL Server backup agent, or Veritas NetBackup for SQL Server, that would be willing to give some recommendations. If you use something that isn't listed here and it works well, I would be interested in hearing about it.
Do these backup agents significantly slow down the database performance? Do they create any locking issues? Some insight into your backup hardware configuration would be helpful as well. Thanks in advance for your help.
3rd Party Monitoring Tools
Apr 11, 2002I have been using the built-in tools of SQL Server (email and netsend) to monitor and alert me about some basic issues (like severity errors and job failures) with our SQL servers. We are now approaching a level and number of servers where I think we need to get a more global and more stable solution to monitoring and alerting.
So what third party tools are you are using to monitor your SQL Servers?
Thanks
SJ
shawn.johnson@kenexa.com
3rd Party Search Engine Web To SQL?
Sep 6, 2005Hi All,
I am pretty new to SQL and would like a bit of friendly help, please. Am trying to set up a .Net web site that will have dynamic content supplied by a true SQL server (am using MSDE to build this first).
My issue is in building a search engine on my web site that will return hits from the content of the pages which are loaded in MSDE.
Is there a third party or open source search engine available?
Any clues for how to build (or beg, borrow or steal) a workable search engine to do this?
Many thanks,
Newbie
Third Party Tools That Add Sp Debugging
Oct 30, 2007The only way I know of to debug a Sql 2005 stored proc is to create a VS2005 Database Project and step into it from there. Does anyone know of any third party tools that adds functionality to Sql Management Studio to step into stored procs?
View 5 Replies View RelatedThird Party Reindexing Utilities
Jul 23, 2005Folks,I work on a system which is growing rapidly, with the number oftransactions we process growing on a daily basis. While this is goodnews or the business, maintenance is starting to become an issue as thedatabase is the backend for a website which cannot be down for alengthy period of time.While I do defrag the indexes, periodically the indexes do need to berebuilt. When this happens, the process locks pages and transactionsstart getting bounced out.Are their any third party utilities which will rebuild an indexwithout this locking occuring? Any help in pointing me in the rightdirection would be appreciated.
View 1 Replies View Related3rd Party Tools For Job Scheduling
Jul 20, 2005I am looking for a better way to schedule jobs in SQL Server. I foundthis tool called SQLschedule at www.idera.com and am using the 30 daytrial. This tool really has a cool GUI, and seems to work well. Doesanyone else have any experience with their tools?
View 1 Replies View RelatedThird Party .NET Charting Packages
Mar 19, 2007Can SSRS be configured to use any third party .NET charting components or only ones that have been specifically designed for SSRS? I have seen a couple of third party charting software (Dundas, etc.) and while they are nice, they sell at a real premium and there are not many vendors offering SSRS charting. I was hoping for a bit better value and more of a selection to choose from.
R
Third Party Supplier Access To SQL
Apr 24, 2008
We have a hosted SQL server with various internal applications on it. It has been decided by on high that the same server will also have a database from a third party on the server. The third party have asked for full system admin rights on the SQL server.
Obviously I am not going to grant that access level as it gives them full control on the box. From my viewpoint read and write access to the data can be tolerated but anything else will be denied. Would you consider this standard and is there any documentation with recommendations for control of external suppliers ?
I am sure that they shouldn`t be doing any work on tables structure, sp`s etc on a live database. That work should be tested, scripted etc and then run on in a controlled environment by my company.
Anyone have any advice ?
Thanks
SI
Third Party Components For SSIS?
Oct 10, 2007hello all -- I'm an SSIS newbie who is exploring (custom) programming functionality through third party components, to be plugged into SSIS, for SMTP, FTP, PGP, TAR, WinZIP, basically for a scheduling & automation utility.
Is there such a concept of third party components (and marketplace for this?) or is VB a much better choice for this vis-a-vis components variety, $$ and robustness ?
thanks much,
Cos
Modifying With 3rd Party Application?
Oct 30, 2006Hi,
I have recently started using SQL Server with a 3rd party application and have come across a problem and i have no idea how to fix it...
The database has a column of numbers that go up either by 10 or 100 depending on the letter in another column. eg:
100 M
110 P
120 P
200 M
300 M
400 M
500 M
510 P
520 P
The 3rd party application has just been updated and now can add new rows to this table. The only problem is that the added row needs a new number, and the rows below need to be recalculated.
Is there anyway this can be done? Any help or suggestions would be great!
Cheers,
BL
CLR Procedure Error With Third Party .dll
Aug 11, 2006I have a CLR procedure with the below code calling a third party .dll in the system32 directory of the SQL server:
using System;
using System.Collections;
using System.Data;
using System.Data.SqlTypes;
using System.Runtime.InteropServices;
using System.Text;
using Microsoft.SqlServer.Server;
public class CorrectAddressProcedures
{
[DllImport(@"C:WINDOWSsystem32CorrectA.dll", EntryPoint = "FindCityCounty")]
public static extern int FindCityCounty(StringBuilder zip, StringBuilder cityname, StringBuilder state, StringBuilder countyname, StringBuilder countynum);
public static String Space(int len)
{
StringBuilder str = new StringBuilder("");
str.Append(' ', len);
return str.ToString();
}
[Microsoft.SqlServer.Server.SqlProcedure]
public static void spFindCityCounty(SqlString _zip, out SqlString _cityname, out SqlString _state, out SqlString _countyname, out SqlString _countynum)
{
int rc;
StringBuilder zip = new StringBuilder(5);
StringBuilder cityname = new StringBuilder(28);
StringBuilder state = new StringBuilder(2);
StringBuilder countyname = new StringBuilder(25);
StringBuilder countynum = new StringBuilder(3);
try
{
cityname.Append(Space(28));
state.Append(Space(2));
countyname.Append(Space(25));
countynum.Append(Space(3));
zip.Append(_zip);
rc = FindCityCounty(zip, cityname, state, countyname, countynum);
_cityname = cityname.ToString();
_state = state.ToString();
_countyname = countyname.ToString();
_countynum = countynum.ToString();
}
catch (Exception ex)
{
throw (ex);
}
}
}
I am getting the error
Msg 6522, Level 16, State 1, Procedure spFindCityCounty, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'spFindCityCounty':
System.DllNotFoundException: Unable to load DLL 'C:WINDOWSsystem32CorrectA.dll': Not enough storage is available to process this command. (Exception from HRESULT: 0x80070008)
System.DllNotFoundException:
at CorrectAddressProcedures.spFindCityCounty(SqlString _zip, SqlString& _cityname, SqlString& _state, SqlString& _countyname, SqlString& _countynum)
.
I have restarted the service with memory allocation settings -g512 and -g1024 but still receive the error. The SQL server is an Intel Xeon 2.8GHZ with 2GB of RAM. Any thoughts of how to solve this would be greatly appreciated.
thanks,
Whitney
Third-party Log Analysis Tools?
Mar 7, 2008
We're looking for a sql server log analysis tool. Currently we often need to identify which users execued DML in the database. But I can see other uses for a product from this tool category. I'm looking at APEXSQL Log and Lumigent Log Explorer.
Can anyone make recommendations for other tools?
Thanks,
Tom
Third Party Installs With Sql 2005
Feb 10, 2008
I completed an install of SQL 2005 SP2 on Windows Server 2003. Everything worked fine I can connect while logged into the box, while connected thru RDP. I can create databases add users without any issue. Until!!!!
I have a third party application (Tririga) which I run the install and indicate the SQL database (in this case local) The application begins to install but when I get to the point of adding the SA password the install fails.
"login fails for sa) 18456 sev 8 (wrong password) but it is the same password I use to connect to the DB. So I change the sa assword and try again and it still fails.
any suggestions would be nice. by the way on machines on which I have run an upgrade from 2000 (sql) to 2005 (sql) the install does not fail.
Export To CSV Fails With 3rd Party Web App
Feb 27, 2007From my web application, exporting to Excel works fine, but when I export to CSV and open with Excel I get 2 garbage characters. I can export the report just fine from the ReportServer.
Is there something special that needs to be done? Could I have an old file?
Could it be something in my report? We always have the following components:
-- textboxes in the page header and footer
-- page header refers to parameter values; page footer refers to globals
-- 2 date parameters and 1 hidden boolean parameters
We're running SQL 2005 Reporting Services, and I have SP2 installed.
(I write the reports, not the web app)
ÿþ
CONNECTING TO SQL SERVER FROM A 3RD PARTY SOFTWARE
May 17, 2008I am trying to use NConstruct to generate my Nhibernate files. i can't connect to the sql server. In the past I have ran into similar problems with MyGeneration and other 3rd party tools. In those cases If I ran the tool as an administrator, it worked out ok. For NConstruct there is no option to run as administrator. I ran the SQL Server Surface Configuration tool to allow local and remote connections for named pipes and tcp already. I read all the blogs written for asp.net, and people often complain about the learning curve for Nhibernate or lack of Tutorials for Nhibernate. What I found in my case is that the steepest learning curve is to get the Microsoft Products Configured and Working Correctly! If anyone can be of any assistance, I would deeply appreciate it
View 1 Replies View RelatedThird Party Software To Manage MSDE?
May 19, 2004Hi, it's my first time to use MSDE. So would you guys please recommend me a third party software or application which has interface to manage it? thank you!
View 1 Replies View RelatedRE:Third Party Audit Log Analysis Product.
May 20, 2000Hi guys,
Does anyone knows of any third party product that does audit log analysis in SQL server.
Thanks in advance
kenny
dba