Skip to main content

SQL SERVER INTEGRATION SREVICE SSIS & FTP Service

Well after the long research i found the auto transfer the data from one system to other or one database to other with in very short time, well this research is based on the transfering of paradox data to the the online server via SSIS.

Well i did not found a pure solution for this issue but after a lenghtly research i found the ways that basically provide me the sucess regarding to this issue

Well the acctual project scope is transfering the paradox data from different local system to the online main website server

the scope seems to be very different and unique well we use SSIS technology for covering this thing


You need following steps to connect your local PC to the online server

1) SSIS (SQL SERVER INTEGRATION SERVICE)
2) SQL SERVER Job Agent

to be honest if the SSIS is not running propoerly then just reinstall the ssis with the propoer SQL custom instanace name because if start i have spend around a week to rectify the issue for running the SSIS but i found the misktake in the installation that we mostly use default instance in sql sever installation and that creates an issue with SSIS and speically reporting server

Well I assume that SSIS is running on your pc in healthy enviroment well let SSIS offer you the left side tool bar same like the visual studio you will select the "For Each loop Container" and double click on it and set the setting

1) General
Give the name i gave Foreach Loop Container

2) Collection
In the "Enumatrator section" D:\Data select the folder that you need to shifted

3) Variable Mapping (This important)
a) Click under the variable heading and Click on the new variable in the dropdown
in container drop down click on the package > Executable > Foreach Loop container
b) Give the name
C) leave user as it is

4) Click ok to exit

Now next is double click on ftp task in the left Toolbox option and put this ftp task under the foreach look container

once you put the ftp task under the foreach loop container then double click on the ftp task
1) General
Leave as it is

2) File Transfer
Is local variable > select true
select the variable that we define in the above steps

Now click ok and then set the connection with live ftp
Click on connect manager
click on new connection
select FTP
and set the ftp credentials

once all things set now click on (not the double click) the ftp again and put the connection manager varaible in the remote connection section

and once you run it the the ftp will shift all files in the specific folder one by one from your local pc to the remote or any other computer

you will set the scheduler by sql job agent eaisly

I hope this blog helps you if you need any further assitance then feel free to contact me at info@bestvisualization.com

Regards
Rashid Imran Bilgrami

Comments

Popular posts from this blog

How to convert and crack windows server 2012 from Evaluation to Full

Dear All

This is a way how you Convert Evalution to Full

Step1:

Open CMD and run following command
DISM /online /Get-CurrentEdition


<edition ID> is like ServerStandard with out Eval

Step 2:
DISM /online /Set-Edition:<edition ID> /ProductKey:XXXXX-XXXXX-XXXXX-XXXXX-XXXXX /AcceptEula



WINDOWS SERVER 2012
Serial Key

Windows Server 2012
DataCenter: 48HP8-DN98B-MYWDG-T2DCC-8W83P
Datacenter: Y4TGP-NPTV9-HTC2H-7MGQ3-DV4TW

Standard: XC9B7-NBPP2-83J2H-RHMBY-92BT4
Standard R2: DBGBW-NPF86-BJVTX-K3WKJ-MTB6V

Server Essentials:K2XGM-NMBT3-2R6Q8-WF2FK-P36R2


For Standard R2 here is a command
For R2 its like that
DISM /online /Set-Edition:ServerStandard /ProductKey:DBGBW-NPF86-BJVTX-K3WKJ-MTB6V /AcceptEula

Regards

RegisterStartupScript updated way to right Java script JS (Javascript) in code behind also work with update panel

Dear All
RegisterStartupScript is obsolete now the new way that works with update panel  is given below its is code behind file code also

VB Code Dim csname1 As String = "PopupScript"
Dim cstype As Type = Me.GetType()
Dim cs As ClientScriptManager = Page.ClientScript
Dim cstext1 As String = "alert('Your message');"
cs.RegisterStartupScript(cstype, csname1, cstext1, True)

C# Code
String csname1 = "PopupScript";
Type cstype = this.GetType();
ClientScriptManager cs = Page.ClientScript;
String cstext1 = "alert('Hello World');"; cs.RegisterStartupScript(cstype, csname1, cstext1, true);
I hope it will help you also 
Regards  Rashid Imran Bilgrami

Calling LoadLibraryEx on ISAPI filter “C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_filter.dll” failed

Dear Readers
if you get the error

Calling LoadLibraryEx on ISAPI filter “C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_filter.dll” failed


Here is the solution 
Get a command prompt in administrator mode and go to C:\Windows\Microsoft .NET\FrameWork64\v4.xxx
and run aspnet_regiis -r. This will re-register the right libraries. It has happened twice already to me.
For other frameworks (32 bit or other versions of .net make sure you go to the correct folder (i.e. Framework/v2.xxx, etc.)

xxxx is the the number which is present with the folder name so i suggest you guys to check the folder name in your directory

If "run aspnet_regiis -r" is not working and if you get the error run is not recognized command then just type " aspnet_regiis -r" it will run fine

Reason of problem
Your asp.net frame work has been change may be you have install the lower version on the higher version or may be because of any reason you have register another version in your IIS, in my cas…