this is an issue regarfding the SQL Severe Integration Services
I have installed the Business Intelligence Studio through SQLEXPR_TOOLKIT.EXE
but the problem is when i am trying to create the SSIS Project it is not showing the SSIS Project Templates in BID .
I have try to change the location of Templates in Tools --> Option --> project & Solution but the still the problem is same
I have created my project template but I want to put my own wizard to ask user about filename with database name that user want to attach in project. and with this name I wanted to start my own windows application to create that cs files / classes of that tables and automatically saved into that project folder..
View 9 RepliesI have a Listview that is connected to an EntityDataSource. What I'm having trouble doing is showing fields of an association in the Item Template rather than just the id.
For example, what it currently shows:
Name: John Doe
Race: 3
What I wish it would show
Name: John Doe
Race: Caucasian
Some example code:
[Code]....
Obviously, I'm getting the number because Race_ID is an integer. What I'm less sure about is how to bind it or Eval it in some manner that will let me match that id to a name in the other table (which is associated). I've tried <%# Eval("Race.Name") %>' and a few other things to try to get a name rather than an ID but I always get either the id or nothing at all.
My desktop management team have just installed visual studio 2008 and there is no plugins for asp.net. Is this missed out while they installed visual studio? Can this to be installed again?
View 2 RepliesI'm trying to create an ASP.NET Web Application, but this is all I see: I have confirmed that I have the full Visual Studio installed, not just Visual C#.Why can't I see ASP.NET Web Application in the "new project" list?
View 1 RepliesI want to replicate data from branch server to main server using SSIS with scheduling .. Every daily at 12 AM. I can have more than 5 branch servers, I need to transfer datas from these server to my main server. how can i do with SSIS and Error handler in SSIS , While replicating if some error happens , it need to save log file or send mail to me Like this i need to do.. and also i need to scedule the created SSIS pac
View 1 RepliesMigrating SSIS package from SQL Server 2005 to SQL Server 2008
View 1 RepliesPrevious developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
I am migrating a project from C#.Net (Console Application that acts as a server) to SSIS 2005 based one as the task involves around Database. I can able to use only VB.Net in SSIS 2005 version. The problem is, the C# code has XSD, XSL operations over XML along with XML processing such as XML creation/generation, compressing the file, and saving the file into DB. As it looks like the above operations are not achieved without using VB.Net in SSIS, I am blindly converting into VB.Net inside SSIS.
Also, I would like to know how to import/create XSD files in VB.Net in SSIS. It is not like Visual Studio to add a new XSD file and design the same that allows generating the appropriate code.
For your information, I am using Typed DataSet.XSD file in C# which needs to be converted into VB.Net in SSIS. There is no provision to add Typed DataSet XSD files into VB.Net in SSIS 2005.
i am trying to create a import package to import data from a CSV file. When I create a flat file source and take a look at the preview I see that the fields are mixed up. Some fields are ok, but quet a few arent. When I open the CSV in excel or a other program it looks good, all rows are ok. When i import the CSV in access it is also ok. So I'm a bit confused where the problem lies. all the settings are standard. The strangest thing is that when i replace al the semicolons to for instance tab's the problem keeps.
View 4 RepliesI have created an SSIS package to fetch the details from an Oracle database and import the details in to SQL servers table. In development region the client provided the connection description for oracle server as shown below: Using the above string
I have selected Microsoft OLE DB provider for Oracle and gave xxxxx:1543/AU1D as server name and provided the username and password. It got connected successfully. (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx.abc.XYZ.com)(PORT = 1543))
)(CONNECT_DATA = (SERVER=dedicated) (SID=AU1D) )) For Prod environment the Oracle servers connection description is: C10P =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = yyyyy.abc.XYZ.com)(PORT = 1524)) (ADDRESS = (PROTOCOL = TCP)(HOST = zzzzz.abc.XYZ.com)(PORT
= 1524)) (ADDRESS = (PROTOCOL = TCP)(HOST = vvvvv.abc.XYZ.com)(PORT = 1524)) (LOAD_BALANCE = yes)(CONNECT_DATA =(SERVICE_NAME = C10P. abc. XYZ.com)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)))) Now I don't have the SID to use in the connection.
i need to create a simple package that will: 1. insert a data to table A2. get the identity_scope3. insert multiple rows to table B with the id from table Ai created one, but it only does bulk insert, so i want to redo it again.
View 1 RepliesSql server 2005 is already installes in my machine.., i want to use SSIS now.where can i download SSIS package as add on to sql server 2005.
View 5 RepliesI have around 10 "Excute SQL Task" events in sequence. Each Task uses the same two date parameters, which are declared at the top of each script. Is there a way to set these two at the start of the process instead of within each sql script?
View 2 Repliesi am using two tables for salary components like bonus,hra,ta,da.one is salary lookup table for viewing which components are chosen and according to this salary table is created dynamically.i want to view data fields of salary table in gridview and update thier value.
now problem is that how to create template field and edit template field for updating fields of salary table because field of the salary table changing every time as it is creating dynamically.
I have recently found this snippet of code but I am unable to get it to work. Does anybody know if the $index syntax has changed in the latest version of the client templates?
[Code]....
I keep recieving $index is undefined.
The offending line is
[Code]....
I have the following list of projects WebUI (WebSite) , DataAccess (ClassLibrary) , LogicLayer(ClassLibrary). Those of the project are purposively crated separately.But my scenario is, need to create only one solution file, then add all of the above projects under this solution file. So that i can be easiy interacted and changes can be made by opening solution file only instead of opening each project individually.
Simply all of the layer projects are under one roof means one solution. I tried it by adding solution first, then i added already existed project into this. But once after added already existing project the solution icon vanished by showing the icon of recently added project. By this way I could not add another project into this section too.Hope this is the way the basic real-time projects are created; to achieve the centralized control over architecture based projects.
Created SSIS package, it runs fine I import it into Stored packages in Integration Services, I right click and click "Run Package" it runs fine Create a new job to run the package and I get errors
The package runs an Execute Package task. That seems to be where the errors occur. But it runs fine in all circumstances except from a "job".
Note: ALL THE ERRORS ARE IN TASKS THAT CONNECT TO A REMOTE SERVER.
[code]....
i'm trying to retrieve the data from database using ssis package.. database name is employee which contains 48 tables and it is around 20GB of memory.. it is a production database..
now what i want is to retrieve the data for each four hours.. i.e i want to execute the package for every 4 hrs..
now what i did is i have taken a database transfer task and from the source i.e production database i want to transfer to my database which works fine..
but what is the problem here is for every 4 hrs whole DB is replaced in my system
i've given overwrite TRUE..
Here user enter the data into database for every 4 hour is minimum 10 MB of data.. instead for replacing the whole database for every 4 hrs is there any solution that what user enter data into database only that much amount of data should be append into my system..
SSIS package is running successfully and the db table is not populating in sql server.I am using csv file to populate datas to database tables.
I am using flat file source and oledb destination in data flow in ssis.
I'm trying to run my SSIS packages as a step inside a sql agent job.This runs normally when the package uses the SAME database as used to create my job.The problem occurs if I create a job to run the package and this package must execute queries in another database. Probably authentication problem. So how to authenticate my package and the job runs normally ?
View 1 RepliesI need to create SSIS Package for Microsoft tool preweblog utility.exe to modify the IIS LogFiles.
View 1 Replieshow to build sqlserver integration services( ssis) package i want to tranfer more than 1000 files of excel data into sqlserver
View 4 RepliesHow to write and deploy SSIS data transfer packages. ?
View 2 RepliesI am new with SSIS, what I need is to search on a specific column in a table.
I am using asp.net with C#, and I dont have a cluw how to start and implement this.